Click Here!
home account info subscribe login search My ITKnowledge FAQ/help site map contact us


 
Brief Full
 Advanced
      Search
 Search Tips
To access the contents, click the chapter and section titles.

Oracle Performance Tuning and Optimization
(Publisher: Macmillan Computer Publishing)
Author(s): Edward Whalen
ISBN: 067230886x
Publication Date: 04/01/96

Bookmark It

Search this book:
 
Previous Table of Contents Next


Enhancements

You may want to make some additional enhancements to improve the performance of the WebServer system:

  Block size. Unlike the OLTP system, the WebServer system may benefit from a larger block size because of the large size of some of the text and image rows. I recommend trying a block size of 4,096 or 8,192.
  Clusters. I don’t think that clusters will be of benefit, but your particular installation may be able to take advantage of them.
  Hash clusters. I don’t think that hash clusters can benefit this type of system.
  Multiblock reads. Because some large amounts of data are read, multiblock reads can be beneficial. The value for multiblock reads should be 64K.
  Parallel Query option. The Oracle Parallel Query option will probably not help significantly in this type of application because there are many different user processes with relatively small queries.
  Parallel Server option. In this type of environment, you may be able to take advantage of both the performance and fault-tolerant features of the Oracle Parallel Server option.

Many of these enhancements can help your performance. The specific effect on your system will vary, but the information given here works well for most cases.

Review of the WebServer System

The WebServer system has the characteristics of both the OLTP and the TextServer systems. By considering both sets of characteristics and looking at the data access patterns, you can design the system to work optimally for both environments. Of course, you may have to make some compromises to accommodate both system types, but these may be minor.

As with the OLTP system, you must be concerned with the user response times in the WebServer system. Whether or not there are significant updates is determined solely by your configuration. Although these systems may not be considered mission critical, uptime may be an issue.

Summary

This chapter looked at several miscellaneous configurations and how to optimize them. You looked at the specific application type and contrasted it to another type of system or set of systems with which you are familiar. Using the general tuning guidelines listed in the preceding chapters and the system-specific guidelines presented in this chapter, you have a reasonable starting point from which to build the system.

From this starting point, you can run some test applications to further characterize the data access patterns and use of Oracle resources in your system. Then you can determine future changes that might benefit the performance of the system.


Previous Table of Contents Next


Products |  Contact Us |  About Us |  Privacy  |  Ad Info  |  Home

Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc.
All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited.